select a.let_id,a.mis_id,a.mis_pos,trunc(a.ver_dtini) ver_dtini,trunc(a.ver_dtfine) ver_dt_fine,
a.lmis_val,a.lmis_valcon,a.faco_id,a.faco_des,
a.lmis_umidval,a.smis_mat,a.valore_precedente,
b.JOB_ID, b.CUF_ID,c.ATT_IDEXT,trunc(d.JOB_DTREG) job_dtreg,c.CON_ANNO,c.CON_ID
from v_letmisval a, 
     lettura b,
     v_conubifrn c,
     v_jobqueue d,
     v_contratto con,
     v_ragfat rag
     
where a.LET_ID= b.LET_ID
and a.az_id='01'
and b.az_id='01'
and c.az_id='01'
and d.az_id='01'
and con.az_id='01'
and rag.az_id='01'
  and b.CUF_ID = c.CUF_ID
  and c.SER_ID ='03'
  and c.STA_IDSYS =2
  and c.CON_ID = con.CON_ID
  and c.CON_ANNO = con.CON_ANNO
  and con.RAGF_ID = rag.RAGF_ID
  and rag.RAGF_ID = 5413
  and rag.STA_IDSYS = 2
  and b.JOB_ID = d.JOB_id (+)
  --and a.let_id = 736286
